Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	65281
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	3657
Duplicate rows (%)	5.6%
Total size in memory	6.0 MiB
Average record size in memory	96.0 B

Variable types

Numeric	9
Text	1
Categorical	2

Alerts

Dataset has 3657 (5.6%) duplicate rows	Duplicates
`Discount Amount` is highly overall correlated with `Sales Amount` and 3 other fields	High correlation
`List Price` is highly overall correlated with `Sales Price` and 1 other fields	High correlation
`Sales Amount` is highly overall correlated with `Discount Amount` and 3 other fields	High correlation
`Sales Amount Based on List Price` is highly overall correlated with `Discount Amount` and 3 other fields	High correlation
`Sales Cost Amount` is highly overall correlated with `Discount Amount` and 3 other fields	High correlation
`Sales Margin Amount` is highly overall correlated with `Discount Amount` and 3 other fields	High correlation
`Sales Price` is highly overall correlated with `List Price` and 1 other fields	High correlation
`Sales Quantity` is highly overall correlated with `List Price` and 1 other fields	High correlation
`Sales Cost Amount` is highly skewed (γ1 = 21.01078573)	Skewed
`Sales Quantity` is highly skewed (γ1 = 23.00739577)	Skewed
`Discount Amount` has 1214 (1.9%) zeros	Zeros

Reproduction

Analysis started	2023-07-10 12:54:24.572202
Analysis finished	2023-07-10 12:54:38.212060
Duration	13.64 seconds
Software version	ydata-profiling vv4.3.1
Download configuration	config.json

CustKey
Real number (ℝ)

Distinct	615
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10017703

Minimum	10000453
Maximum	10027583
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	510.1 KiB

Quantile statistics

Minimum	10000453
5-th percentile	10002506
Q1	10012715
median	10019665
Q3	10023511
95-th percentile	10026006
Maximum	10027583
Range	27130
Interquartile range (IQR)	10796

Descriptive statistics

Standard deviation	7176.1904
Coefficient of variation (CV)	0.0007163509
Kurtosis	-0.37137474
Mean	10017703
Median Absolute Deviation (MAD)	4886
Skewness	-0.77019433
Sum	6.5396565 × 10¹¹
Variance	51497708
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10025919	2760	4.2%
10019194	2752	4.2%
10012715	1431	2.2%
10012226	1389	2.1%
10025025	1143	1.8%
10023524	1042	1.6%
10020515	1010	1.5%
10017638	792	1.2%
10022456	741	1.1%
10002506	714	1.1%
Other values (605)	51507	78.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10000453	329	0.5%
10000455	19	< 0.1%
10000456	104	0.2%
10000457	19	< 0.1%
10000458	10	< 0.1%
10000460	120	0.2%
10000461	251	0.4%
10000462	3	< 0.1%
10000466	123	0.2%
10000469	162	0.2%

Value	Count	Frequency (%)
10027583	25	< 0.1%
10027575	5	< 0.1%
10027572	52	0.1%
10027560	42	0.1%
10027381	108	0.2%
10027370	235	0.4%
10027356	21	< 0.1%
10027348	14	< 0.1%
10027340	35	0.1%
10027119	176	0.3%

Discount Amount
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	17821
Distinct (%)	27.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1855.5748

Minimum	-255820.8
Maximum	343532.66
Zeros	1214
Zeros (%)	1.9%
Negative	972
Negative (%)	1.5%
Memory size	510.1 KiB

Quantile statistics

Minimum	-255820.8
5-th percentile	18.68
Q1	246.04
median	441.76
Q3	999.76
95-th percentile	6353
Maximum	343532.66
Range	599353.46
Interquartile range (IQR)	753.72

Descriptive statistics

Standard deviation	9037.0717
Coefficient of variation (CV)	4.8702275
Kurtosis	379.74222
Mean	1855.5748
Median Absolute Deviation (MAD)	233.95
Skewness	10.841862
Sum	1.2113378 × 10⁸
Variance	81668664
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1214	1.9%
24.88	103	0.2%
606.84	100	0.2%
639.82	97	0.1%
634.6133	93	0.1%
402.7	93	0.1%
601.9033	93	0.1%
918.1412	88	0.1%
385.98	87	0.1%
169.36	87	0.1%
Other values (17811)	63226	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-255820.8	1	< 0.1%
-245587.97	1	< 0.1%
-238792.73	1	< 0.1%
-231837.6	3	< 0.1%
-222564.1	3	< 0.1%
-127176	1	< 0.1%
-122088.96	1	< 0.1%
-84573.72	1	< 0.1%
-81190.77	1	< 0.1%
-53626	1	< 0.1%

Value	Count	Frequency (%)
343532.66	2	< 0.1%
339103.35	1	< 0.1%
331487.76	2	< 0.1%
327213.75	1	< 0.1%
322454.09	1	< 0.1%
210371	4	< 0.1%
202995	4	< 0.1%
191196.5532	2	< 0.1%
189333.9	1	< 0.1%
182832.8832	2	< 0.1%

Item
Text

Distinct	657
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	510.1 KiB

Length

Max length	37
Median length	32
Mean length	21.722278
Min length	8

Characters and Unicode

Total characters	1418052
Distinct characters	56
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	30 ?
Unique (%)	< 0.1%

Sample

1st row	Nationeel Salted Pretzels
2nd row	Ebony Prepared Salad
3rd row	Thresher Spicy Mints
4th row	Big Time Frozen Cheese Pizza
5th row	Red Spade Turkey Hot Dogs

Value	Count	Frequency (%)
canned	6378	2.8%
ebony	5460	2.4%
cheese	5194	2.3%
better	4570	2.0%
red	4271	1.9%
top	4173	1.8%
spade	4161	1.8%
high	4138	1.8%
best	3480	1.5%
nationeel	3328	1.4%
Other values (294)	184534	80.3%

Most occurring characters

Value	Count	Frequency (%)
	164406	11.6%
e	147096	10.4%
o	92467	6.5%
a	92276	6.5%
n	74074	5.2%
i	69460	4.9%
t	68733	4.8%
r	67352	4.7%
l	59835	4.2%
s	57796	4.1%
Other values (46)	524557	37.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1013747	71.5%
Uppercase Letter	236243	16.7%
Space Separator	164406	11.6%
Dash Punctuation	2160	0.2%
Other Punctuation	748	0.1%
Decimal Number	748	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	147096	14.5%
o	92467	9.1%
a	92276	9.1%
n	74074	7.3%
i	69460	6.9%
t	68733	6.8%
r	67352	6.6%
l	59835	5.9%
s	57796	5.7%
d	40545	4.0%
Other values (16)	244113	24.1%

Uppercase Letter

Value	Count	Frequency (%)
B	31428	13.3%
C	30873	13.1%
S	26130	11.1%
T	19374	8.2%
F	16239	6.9%
M	12522	5.3%
P	11469	4.9%
L	11022	4.7%
D	10754	4.6%
E	10237	4.3%
Other values (15)	56195	23.8%

Decimal Number

Value	Count	Frequency (%)
1	579	77.4%
2	169	22.6%

Space Separator

Value	Count	Frequency (%)
	164406	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2160	100.0%

Other Punctuation

Value	Count	Frequency (%)
%	748	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1249990	88.1%
Common	168062	11.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	147096	11.8%
o	92467	7.4%
a	92276	7.4%
n	74074	5.9%
i	69460	5.6%
t	68733	5.5%
r	67352	5.4%
l	59835	4.8%
s	57796	4.6%
d	40545	3.2%
Other values (41)	480356	38.4%

Common

Value	Count	Frequency (%)
	164406	97.8%
-	2160	1.3%
%	748	0.4%
1	579	0.3%
2	169	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1418052	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	164406	11.6%
e	147096	10.4%
o	92467	6.5%
a	92276	6.5%
n	74074	5.2%
i	69460	4.9%
t	68733	4.8%
r	67352	4.7%
l	59835	4.2%
s	57796	4.1%
Other values (46)	524557	37.0%

List Price
Real number (ℝ)

HIGH CORRELATION

Distinct	1062
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	514.70126

Minimum	0
Maximum	2760.7
Zeros	295
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	510.1 KiB

Quantile statistics

Minimum	0
5-th percentile	36.69
Q1	181.56
median	325.19
Q3	803.86
95-th percentile	1431.23
Maximum	2760.7
Range	2760.7
Interquartile range (IQR)	622.3

Descriptive statistics

Standard deviation	449.18811
Coefficient of variation (CV)	0.87271615
Kurtosis	0.012496642
Mean	514.70126
Median Absolute Deviation (MAD)	217.35
Skewness	1.0054596
Sum	33600213
Variance	201769.95
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
298	1508	2.3%
1431.23	1426	2.2%
966.44	1192	1.8%
1275.1	1126	1.7%
192.34	1041	1.6%
1627.84	1035	1.6%
157.76	988	1.5%
1084.61	975	1.5%
181.44	893	1.4%
412.03	892	1.4%
Other values (1052)	54205	83.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	295	0.5%
0.3929	150	0.2%
0.4	21	< 0.1%
0.405	25	< 0.1%
0.41	10	< 0.1%
0.445	6	< 0.1%
0.52	1	< 0.1%
0.61	4	< 0.1%
1.6236	2	< 0.1%
1.8711	9	< 0.1%

Value	Count	Frequency (%)
2760.7	12	< 0.1%
2291.4	7	< 0.1%
2267	10	< 0.1%
1975	113	0.2%
1920	61	0.1%
1880	19	< 0.1%
1759.4	45	0.1%
1731.4	35	0.1%
1691.4	12	< 0.1%
1688.13	150	0.2%

Sales Amount
Real number (ℝ)

HIGH CORRELATION

Distinct	17895
Distinct (%)	27.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2852.0055

Minimum	200.01
Maximum	555376
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	510.1 KiB

Quantile statistics

Minimum	200.01
5-th percentile	215.78
Q1	308.38
median	553.94
Q3	1279.96
95-th percentile	8777.79
Maximum	555376
Range	555175.99
Interquartile range (IQR)	971.58

Descriptive statistics

Standard deviation	15164.456
Coefficient of variation (CV)	5.3171202
Kurtosis	478.90724
Mean	2852.0055
Median Absolute Deviation (MAD)	292.92
Skewness	18.578552
Sum	1.8618177 × 10⁸
Variance	2.2996072 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
784.97	115	0.2%
817.68	115	0.2%
294.72	110	0.2%
307	104	0.2%
597.14	102	0.2%
622.02	101	0.2%
824.39	100	0.2%
791.41	99	0.2%
401.16	95	0.1%
204.66	92	0.1%
Other values (17885)	64248	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
200.01	6	< 0.1%
200.06	6	< 0.1%
200.08	1	< 0.1%
200.14	3	< 0.1%
200.15	5	< 0.1%
200.19	7	< 0.1%
200.21	1	< 0.1%
200.3	3	< 0.1%
200.36	1	< 0.1%
200.37	6	< 0.1%

Value	Count	Frequency (%)
555376	1	< 0.1%
539200	5	< 0.1%
517632	5	< 0.1%
472069.6	2	< 0.1%
458320	5	< 0.1%
439987.2	5	< 0.1%
310156.07	1	< 0.1%
301122.4	2	< 0.1%
297240	1	< 0.1%
289077.5	2	< 0.1%

Sales Amount Based on List Price
Real number (ℝ)

HIGH CORRELATION

Distinct	4060
Distinct (%)	6.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4707.5457

Minimum	0
Maximum	632610.16
Zeros	295
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	510.1 KiB

Quantile statistics

Minimum	0
5-th percentile	390
Q1	561.04
median	998.16
Q3	2315.04
95-th percentile	16425.12
Maximum	632610.16
Range	632610.16
Interquartile range (IQR)	1754

Descriptive statistics

Standard deviation	20696.594
Coefficient of variation (CV)	4.3964722
Kurtosis	278.71143
Mean	4707.5457
Median Absolute Deviation (MAD)	524.88
Skewness	14.074724
Sum	3.0731329 × 10⁸
Variance	4.2834901 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1431.23	590	0.9%
1627.84	530	0.8%
803.86	498	0.8%
596	448	0.7%
1254.1899	418	0.6%
966.44	376	0.6%
439.7	372	0.6%
507.75	363	0.6%
767.75	348	0.5%
939.57	343	0.5%
Other values (4050)	60995	93.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	295	0.5%
194	2	< 0.1%
195.61	1	< 0.1%
198.396	1	< 0.1%
198.63	1	< 0.1%
200.7	8	< 0.1%
200.8	1	< 0.1%
201.69	3	< 0.1%
202.14	1	< 0.1%
202.6	1	< 0.1%

Value	Count	Frequency (%)
632610.16	5	< 0.1%
624453.75	2	< 0.1%
539200	11	< 0.1%
458320	12	< 0.1%
391924.7232	5	< 0.1%
387395	8	< 0.1%
348655.5	2	< 0.1%
332196.405	2	< 0.1%
330708.3792	5	< 0.1%
310273.7392	2	< 0.1%

Sales Cost Amount
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	5513
Distinct (%)	8.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1661.0047

Minimum	0
Maximum	366576
Zeros	348
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	510.1 KiB

Quantile statistics

Minimum	0
5-th percentile	85.36
Q1	167.79
median	304.5
Q3	687.4
95-th percentile	4946.11
Maximum	366576
Range	366576
Interquartile range (IQR)	519.61

Descriptive statistics

Standard deviation	9556.5562
Coefficient of variation (CV)	5.7534794
Kurtosis	614.26709
Mean	1661.0047
Median Absolute Deviation (MAD)	171.25
Skewness	21.010786
Sum	1.0843205 × 10⁸
Variance	91327767
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
449.69	534	0.8%
475.75	457	0.7%
0	348	0.5%
134.67	305	0.5%
162.89	289	0.4%
205.72	253	0.4%
159.14	242	0.4%
16718.08	234	0.4%
546.44	231	0.4%
344.28	229	0.4%
Other values (5503)	62159	95.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	348	0.5%
12.97	2	< 0.1%
19.55	4	< 0.1%
20.8	6	< 0.1%
26	1	< 0.1%
31.19	4	< 0.1%
33.97	3	< 0.1%
35.48	2	< 0.1%
35.54	5	< 0.1%
36.03	1	< 0.1%

Value	Count	Frequency (%)
366576	7	< 0.1%
353292.8	4	< 0.1%
311589.6	12	< 0.1%
185048.85	2	< 0.1%
161446.35	5	< 0.1%
157412.85	2	< 0.1%
153635.03	5	< 0.1%
146630.4	4	< 0.1%
141265.56	36	0.1%
137736.24	4	< 0.1%

Sales Margin Amount
Real number (ℝ)

HIGH CORRELATION

Distinct	21295
Distinct (%)	32.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1191.0008

Minimum	-3932.93
Maximum	188800
Zeros	3
Zeros (%)	< 0.1%
Negative	576
Negative (%)	0.9%
Memory size	510.1 KiB

Quantile statistics

Minimum	-3932.93
5-th percentile	61.54
Q1	129.95
median	246.49
Q3	579.32
95-th percentile	3824.43
Maximum	188800
Range	192732.93
Interquartile range (IQR)	449.37

Descriptive statistics

Standard deviation	5860.8134
Coefficient of variation (CV)	4.9209148
Kurtosis	324.93262
Mean	1191.0008
Median Absolute Deviation (MAD)	140.28
Skewness	15.571533
Sum	77749723
Variance	34349134
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
374.7	93	0.1%
5317.17	88	0.1%
6235.31	87	0.1%
341.72	84	0.1%
15.32	69	0.1%
52.8	67	0.1%
37.08	67	0.1%
431.88	64	0.1%
464.59	64	0.1%
24.53	63	0.1%
Other values (21285)	64535	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3932.93	1	< 0.1%
-3764.4	2	< 0.1%
-3673.68	2	< 0.1%
-3608.81	1	< 0.1%
-3414.01	2	< 0.1%
-3132.65	2	< 0.1%
-2533.97	2	< 0.1%
-2508.21	2	< 0.1%
-2488.89	1	< 0.1%
-2103.04	2	< 0.1%

Value	Count	Frequency (%)
188800	1	< 0.1%
185907.2	2	< 0.1%
172624	3	< 0.1%
164339.2	2	< 0.1%
160480	2	< 0.1%
156773.4	1	< 0.1%
156521.04	1	< 0.1%
151056	3	< 0.1%
148401.6	3	< 0.1%
147487.37	2	< 0.1%

Sales Price
Real number (ℝ)

HIGH CORRELATION

Distinct	14789
Distinct (%)	22.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	283.69685

Minimum	0.33734118
Maximum	6035
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	510.1 KiB

Quantile statistics

Minimum	0.33734118
5-th percentile	22.425556
Q1	100.07
median	183.759
Q3	448.22
95-th percentile	789.66
Maximum	6035
Range	6034.6627
Interquartile range (IQR)	348.15

Descriptive statistics

Standard deviation	252.02973
Coefficient of variation (CV)	0.88837691
Kurtosis	6.8826841
Mean	283.69685
Median Absolute Deviation (MAD)	116.471
Skewness	1.4189862
Sum	18520014
Variance	63518.984
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
140.43	191	0.3%
817.68	189	0.3%
133.41	181	0.3%
824.39	138	0.2%
783.17	138	0.2%
23.47	136	0.2%
82.87333333	125	0.2%
230.98	120	0.2%
221.04	120	0.2%
230.25	120	0.2%
Other values (14779)	63823	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.3373411765	2	< 0.1%
0.3514	1	< 0.1%
0.3619411765	1	< 0.1%
0.37718	67	0.1%
0.384	9	< 0.1%
0.3888	12	< 0.1%
0.3929	67	0.1%
0.3936	5	< 0.1%
0.4	9	< 0.1%
0.40469	16	< 0.1%

Value	Count	Frequency (%)
6035	1	< 0.1%
3748	2	< 0.1%
3233.36	1	< 0.1%
3009.86	1	< 0.1%
3003.41	1	< 0.1%
2823	1	< 0.1%
2753.32	1	< 0.1%
2560	1	< 0.1%
2540.17	1	< 0.1%
2360.1	1	< 0.1%

Sales Quantity
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	280
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45.085017

Minimum	0
Maximum	16000
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	510.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	8
95-th percentile	86
Maximum	16000
Range	16000
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	429.66505
Coefficient of variation (CV)	9.5301072
Kurtosis	649.74753
Mean	45.085017
Median Absolute Deviation (MAD)	2
Skewness	23.007396
Sum	2943195
Variance	184612.05
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	15264	23.4%
2	13466	20.6%
3	7056	10.8%
4	4973	7.6%
5	3519	5.4%
6	3061	4.7%
10	2596	4.0%
8	1460	2.2%
12	1314	2.0%
20	1034	1.6%
Other values (270)	11538	17.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	15264	23.4%
2	13466	20.6%
3	7056	10.8%
4	4973	7.6%
5	3519	5.4%
6	3061	4.7%
7	711	1.1%
8	1460	2.2%
9	453	0.7%

Value	Count	Frequency (%)
16000	11	< 0.1%
13600	12	< 0.1%
9504	7	< 0.1%
8316	40	0.1%
7128	21	< 0.1%
7126	2	< 0.1%
6480	2	< 0.1%
6400	4	< 0.1%
5834	4	< 0.1%
4752	13	< 0.1%

Year
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	510.1 KiB

2017	30574
2019	28021
2018	6686

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	261124
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017
2nd row	2017
3rd row	2017
4th row	2017
5th row	2017

Common Values

Value	Count	Frequency (%)
2017	30574	46.8%
2019	28021	42.9%
2018	6686	10.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2017	30574	46.8%
2019	28021	42.9%
2018	6686	10.2%

Most occurring characters

Value	Count	Frequency (%)
2	65281	25.0%
0	65281	25.0%
1	65281	25.0%
7	30574	11.7%
9	28021	10.7%
8	6686	2.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	261124	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	65281	25.0%
0	65281	25.0%
1	65281	25.0%
7	30574	11.7%
9	28021	10.7%
8	6686	2.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	261124	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	65281	25.0%
0	65281	25.0%
1	65281	25.0%
7	30574	11.7%
9	28021	10.7%
8	6686	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	261124	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	65281	25.0%
0	65281	25.0%
1	65281	25.0%
7	30574	11.7%
9	28021	10.7%
8	6686	2.6%

Month
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	510.1 KiB

Mar	7308
Feb	6556
Jan	6066
Dec	5645
Sep	5555
Other values (7)	34151

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	195843
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jan
2nd row	Jan
3rd row	Jan
4th row	Jan
5th row	Jan

Common Values

Value	Count	Frequency (%)
Mar	7308	11.2%
Feb	6556	10.0%
Jan	6066	9.3%
Dec	5645	8.6%
Sep	5555	8.5%
Jun	5376	8.2%
Oct	5250	8.0%
Nov	5247	8.0%
May	5167	7.9%
Aug	4738	7.3%
Other values (2)	8373	12.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mar	7308	11.2%
feb	6556	10.0%
jan	6066	9.3%
dec	5645	8.6%
sep	5555	8.5%
jun	5376	8.2%
oct	5250	8.0%
nov	5247	8.0%
may	5167	7.9%
aug	4738	7.3%
Other values (2)	8373	12.8%

Most occurring characters

Value	Count	Frequency (%)
a	18541	9.5%
e	17756	9.1%
J	15838	8.1%
u	14510	7.4%
M	12475	6.4%
n	11442	5.8%
r	11285	5.8%
c	10895	5.6%
p	9532	4.9%
A	8715	4.4%
Other values (12)	64854	33.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	130562	66.7%
Uppercase Letter	65281	33.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	18541	14.2%
e	17756	13.6%
u	14510	11.1%
n	11442	8.8%
r	11285	8.6%
c	10895	8.3%
p	9532	7.3%
b	6556	5.0%
t	5250	4.0%
o	5247	4.0%
Other values (4)	19548	15.0%

Uppercase Letter

Value	Count	Frequency (%)
J	15838	24.3%
M	12475	19.1%
A	8715	13.3%
F	6556	10.0%
D	5645	8.6%
S	5555	8.5%
O	5250	8.0%
N	5247	8.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	195843	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	18541	9.5%
e	17756	9.1%
J	15838	8.1%
u	14510	7.4%
M	12475	6.4%
n	11442	5.8%
r	11285	5.8%
c	10895	5.6%
p	9532	4.9%
A	8715	4.4%
Other values (12)	64854	33.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	195843	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	18541	9.5%
e	17756	9.1%
J	15838	8.1%
u	14510	7.4%
M	12475	6.4%
n	11442	5.8%
r	11285	5.8%
c	10895	5.6%
p	9532	4.9%
A	8715	4.4%
Other values (12)	64854	33.1%

Auto

Heatmap
Table

	CustKey	Discount Amount	List Price	Sales Amount	Sales Amount Based on List Price	Sales Cost Amount	Sales Margin Amount	Sales Price	Sales Quantity	Year	Month
CustKey	1.000	-0.016	-0.008	0.015	0.006	0.019	0.011	-0.004	0.011	0.171	0.048
Discount Amount	-0.016	1.000	0.438	0.823	0.896	0.783	0.731	0.367	0.380	0.000	0.015
List Price	-0.008	0.438	1.000	0.356	0.383	0.389	0.285	0.977	-0.542	0.005	0.023
Sales Amount	0.015	0.823	0.356	1.000	0.967	0.930	0.890	0.358	0.484	0.011	0.006
Sales Amount Based on List Price	0.006	0.896	0.383	0.967	1.000	0.913	0.859	0.346	0.476	0.000	0.008
Sales Cost Amount	0.019	0.783	0.389	0.930	0.913	1.000	0.706	0.373	0.423	0.000	0.005
Sales Margin Amount	0.011	0.731	0.285	0.890	0.859	0.706	1.000	0.300	0.474	0.012	0.005
Sales Price	-0.004	0.367	0.977	0.358	0.346	0.373	0.300	1.000	-0.567	0.024	0.011
Sales Quantity	0.011	0.380	-0.542	0.484	0.476	0.423	0.474	-0.567	1.000	0.000	0.004
Year	0.171	0.000	0.005	0.011	0.000	0.000	0.012	0.024	0.000	1.000	0.370
Month	0.048	0.015	0.023	0.006	0.008	0.005	0.005	0.011	0.004	0.370	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	CustKey	Discount Amount	Item	List Price	Sales Amount	Sales Amount Based on List Price	Sales Cost Amount	Sales Margin Amount	Sales Price	Sales Quantity	Year	Month
0	10000460	158.04	Nationeel Salted Pretzels	181.44	204.84	362.88	59.73	145.11	102.420000	2	2017	Jan
1	10000460	420.90	Ebony Prepared Salad	966.44	545.54	966.44	278.38	267.16	545.540000	1	2017	Jan
2	10000460	663.41	Thresher Spicy Mints	507.75	859.84	1523.25	488.68	371.16	286.613333	3	2017	Jan
3	10000460	179.45	Big Time Frozen Cheese Pizza	412.03	232.58	412.03	84.23	148.35	232.580000	1	2017	Jan
4	10000460	1516.52	Red Spade Turkey Hot Dogs	1160.70	1965.58	3482.10	957.15	1008.43	655.193333	3	2017	Jan
5	10000460	274.83	Ebony Canned Peanuts	157.76	356.21	631.04	237.28	118.93	89.052500	4	2017	Jan
6	10004302	495.15	Even Better Low Fat String Cheese	561.04	626.93	1122.08	395.98	230.95	313.465000	2	2017	Jan
7	10006862	232.25	Even Better String Cheese	263.15	294.05	526.30	203.05	91.00	147.025000	2	2017	Jan
8	10006862	247.58	Even Better Low Fat String Cheese	561.04	313.46	561.04	197.99	115.47	313.460000	1	2017	Jan
9	10006862	330.09	Washington Cranberry Juice	187.01	417.95	748.04	211.87	206.08	104.487500	4	2017	Jan

	CustKey	Discount Amount	Item	List Price	Sales Amount	Sales Amount Based on List Price	Sales Cost Amount	Sales Margin Amount	Sales Price	Sales Quantity	Year	Month
65271	10023511	489.0600	BBB Best Apple Butter	515.1400	541.22	1030.2800	307.80	233.42	270.610000	2	2019	Dec
65272	10023511	684.2800	Walrus Light Beer	288.3100	757.27	1441.5500	465.89	291.38	151.454000	5	2019	Dec
65273	10023793	917.5200	Ebony Prepared Salad	966.4400	1015.36	1932.8800	544.55	470.81	507.680000	2	2019	Dec
65274	10023793	2662.4500	Moms Sliced Ham	101.0000	2387.55	5050.0000	1467.83	919.72	47.751000	50	2019	Dec
65275	10026081	397.8448	Better Rice Soup	38.5506	9548.21	9946.0548	4826.77	4721.44	37.008566	258	2019	Dec
65276	10026081	272.5230	Better Fancy Canned Sardines	39.1545	6540.36	6812.8830	2969.78	3570.58	37.588276	174	2019	Dec
65277	10026081	548.2520	Monarch Spaghetti	40.3128	13158.10	13706.3520	6424.27	6733.83	38.700294	340	2019	Dec
65278	10026081	26.2588	Moms Cole Slaw	27.3537	630.23	656.4888	421.22	209.01	26.259583	24	2019	Dec
65279	10026081	447.6400	Swell Canned Peaches	14.2560	10743.32	11190.9600	6258.02	4485.30	13.685758	785	2019	Dec
65280	10026606	15.7200	Walrus Chardonnay	0.3929	377.18	392.9000	340.10	37.08	0.377180	1000	2019	Dec

Most frequently occurring

	CustKey	Discount Amount	Item	List Price	Sales Amount	Sales Amount Based on List Price	Sales Cost Amount	Sales Margin Amount	Sales Price	Sales Quantity	Year	Month	# duplicates
3093	10025552	601.9033	Washington Apple Drink	1419.5833	817.68	1419.5833	353.09	464.59	817.68	1	2017	Oct	21
850	10013080	634.6133	Washington Apple Drink	1419.5833	784.97	1419.5833	353.09	431.88	784.97	1	2019	Dec	20
852	10013080	634.6133	Washington Apple Drink	1419.5833	784.97	1419.5833	353.09	431.88	784.97	1	2019	Oct	20
3090	10025552	601.9033	Washington Apple Drink	1419.5833	817.68	1419.5833	353.09	464.59	817.68	1	2017	Dec	20
422	10008638	24.8800	High Top Walnuts	622.0200	597.14	622.0200	286.38	310.76	597.14	1	2019	Jun	16
851	10013080	634.6133	Washington Apple Drink	1419.5833	784.97	1419.5833	353.09	431.88	784.97	1	2019	Nov	16
2389	10021986	0.0000	High Top Walnuts	622.0200	622.02	622.0200	286.38	335.64	622.02	1	2017	Jun	15
425	10008638	24.8800	High Top Walnuts	622.0200	597.14	622.0200	287.65	309.49	597.14	1	2019	Dec	14
853	10013080	634.6133	Washington Apple Drink	1419.5833	784.97	1419.5833	359.20	425.77	784.97	1	2019	Mar	14
854	10013080	634.6133	Washington Apple Drink	1419.5833	784.97	1419.5833	359.20	425.77	784.97	1	2019	Sep	14

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring